﻿USE [slqj]
GO
/****** Object:  Table [dbo].[XYZSystemConfig]    Script Date: 08/05/2011 14:15:52 ******/
DROP TABLE [dbo].[XYZSystemConfig]
GO
/****** Object:  Table [dbo].[XYZSystemConfig]    Script Date: 08/05/2011 14:15:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[XYZSystemConfig](
	[SystemConfigID] [int] IDENTITY(1,1) NOT NULL,
	[ConfigName] [nvarchar](50) NOT NULL,
	[ConfigValue] [ntext] NOT NULL,
	[DBTypeName] [nvarchar](50) NOT NULL,
	[Description] [ntext] NULL,
 CONSTRAINT [PK_XYZSystemConfig] PRIMARY KEY CLUSTERED 
(
	[SystemConfigID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统配置信息ID(主键)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig', @level2type=N'COLUMN',@level2name=N'SystemConfigID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统配置信息名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig', @level2type=N'COLUMN',@level2name=N'ConfigName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统配置信息数值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig', @level2type=N'COLUMN',@level2name=N'ConfigValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据类型名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig', @level2type=N'COLUMN',@level2name=N'DBTypeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统配置信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'XYZSystemConfig'
GO
SET IDENTITY_INSERT [dbo].[XYZSystemConfig] ON
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (1, N'cfg_alipay_partnter', N'3i3zNhO3ALtfSwaYd4IpSAxS6nQxuPOR', N'nvarchar(100)', N'支付宝合作伙伴Id')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (2, N'cfg_alipay_seller_email', N'XrP3v5MiWDFxtEkEp5Gws3GOppNbep3T', N'nvarchar(100)', N'商家Email')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (3, N'cfg_alipay_notify_url', N'EdC4cP1W3dZ38IEXV+e4nYMVDrbeDBOr', N'nvarchar(100)', N'通知Url')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (4, N'cfg_alipay_return_url', N'Wt1ICd6J3szVC50AVM4HKJYYoESfLGtp', N'nvarchar(100)', N'返回Url')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (5, N'cfg_alipay_show_url', N'T2f2ItMgBT5j6PAei4qvThUend2MiFGFuNgi2+NTfuI=', N'nvarchar(100)', N'商品展示Url')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (6, N'cfg_alipay_key', N'JYNWNs8Uj1SyQak9jzPRdzelJc/vOnudxAzP53/mK2P7PVfhKrsNHA==', N'nvarchar(100)', N'安全检验码')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (7, N'cfg_alipay_account_name', N'xPY4DkmTKl+9v0cX9ly3Sg==', N'nvarchar(100)', N'支付宝帐户名')
INSERT [dbo].[XYZSystemConfig] ([SystemConfigID], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (8, N'cfg_alipay_batch_notify_url', N'qattqT8JwuXNgOUvoXcFD2pUa4bWkm1J', N'nvarchar(100)', N'批量支付通知')
SET IDENTITY_INSERT [dbo].[XYZSystemConfig] OFF

SET IDENTITY_INSERT [dbo].[AuthPermissions] ON
INSERT [dbo].[AuthPermissions] ([PermissionsID], [PermissionCode], [PermissionName], [PermissionGroup], [Description], [Url], [UerType], [GroupSort], [PermissionSort]) VALUES (43, N'1010', N'新银盏系统配置管理', N'系统管理', N'系统管理', N'/admin/XYZMgr/XYZSystemConfigMgr.aspx', 1, 1, 0)
SET IDENTITY_INSERT [dbo].[AuthPermissions] OFF
